﻿CREATE TABLE [dbo].[ASMS_Automobile]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[Number] nvarchar(32),
	[CustomerId] uniqueidentifier not null,
	[Owner] nvarchar(32) not null,
	[OwnerTelephone] nvarchar(32) not null,
	[LPN] nvarchar(64) not null,
	[VIN] nvarchar(64) not null,
	[EIN] nvarchar(64) not null,
	[EngineType] nvarchar(32),
	[Brand] nvarchar(32) ,
	[Maker] nvarchar(32) ,
	[Series] nvarchar(32) ,
	[Model] nvarchar(32),
	[BoughtDate] datetime,
	[InsuranceCompany] nvarchar(32) ,
	[InsuranceExpirationDate] datetime,
	[InsuranceNumber] nvarchar(64),
	[NextAnnualSurveyDate] datetime, 
    [NextMaintenanceDate] datetime NULL,
	[NextReplaceTireDate] datetime,
	[AppSyncedTime] datetime,
	[OfflineId] uniqueidentifier,
	[Creator] nvarchar(64) not NULL,
	[CreatedTime] datetime not NULL,
	[Status] int not null
)
